var habitSQL = {
    insert: 'insert into signin_habit (habitid, habitname, habitdesc, createtime) values (?, ?, ?, ?)',
    updateName: 'update signin_habit set habitname = ? where habitid = ?',
    updateDesc: 'update signin_habit set habitdesc = ? where habitid = ?',
    deleteHabit: 'update signin_habit set isuse = 0 where habitid = ?',
    selectById: 'select * from signin_habit where habitid = ? and isuse = 1',
    selectAll: 'select * from signin_habit where isuse = 1'
};

module.exports = habitSQL;